package cn.itcast.bos.web.action.base;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Join;
import javax.persistence.criteria.JoinType;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;

import org.apache.commons.lang3.StringUtils;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.apache.struts2.convention.annotation.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Controller;

import cn.itcast.bos.domain.base.Courier;
import cn.itcast.bos.domain.base.Standard;
import cn.itcast.bos.service.base.CourierService;
import cn.itcast.bos.web.action.common.BaseAction;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import com.opensymphony.xwork2.ModelDriven;


/***
 * 快递员
 * @author YML
 *
 */
@ParentPackage("json-default")
@Namespace("/")
@Controller
@Scope("prototye")
public class CourierAction extends BaseAction<Courier>{
	
	
	
	@Autowired
	private CourierService courierService;
	
	//添加快递员方法
	@Action(value="courier_save",results={@Result(name="success" ,location="./pages/base/courier.html" , type="redirect")})
	public String save(){
		courierService.save(model);
		return SUCCESS;
		
	}
	
	//属性驱动
	private int page;
	private int rows;

	public void setPage(int page) {
		this.page = page;
	}
	public void setRows(int rows) {
		this.rows = rows;
	}
	
	//分页查询方法
	@Action(value="courier_pageQuery",results={@Result(name="success" , type="json")})
	public String pageQuery(){
		//封装Pageable对象
		Pageable pageable = new PageRequest(page-1, rows);
		
		//根据查询条件，构造Specification 条件查询对象
		Specification<Courier> specification = new Specification<Courier>() {
			
			@Override
			//构造条件查询方法，如果方法返回null，代表是无条件查询
			public Predicate toPredicate(Root<Courier> root, CriteriaQuery<?> query,
					CriteriaBuilder cb) {
				//当前查询root根对象Courier
				List<Predicate> list = new ArrayList<Predicate>();
					//单表查询（查询当前对象，对应数据表）
				if (StringUtils.isNotBlank(model.getCourierNum())) {
					//进行快递员工号查询
					//courierNum=?
					Predicate p1 = cb.equal(root.get("courierNum").as(String.class), model.getCourierNum());
					list.add(p1);
				}
				if (StringUtils.isNotBlank(model.getCompany())) {
					//进行公司查询，模糊查询
					Predicate p2 = cb.like(root.get("company").as(String.class), "%"+model.getStandard().getName()+"%");
					list.add(p2);
				}
				if (StringUtils.isNotBlank(model.getType())) {
					Predicate p3 = cb.equal(root.get("type").as(String.class),
							model.getType());
					list.add(p3);
				}
				// 多表查询
				Join<Courier, Standard> standardJoin = root.join("standard",
						JoinType.INNER);
				if (model.getStandard() != null
						&& StringUtils.isNotBlank(model.getStandard()
								.getName())) {
					Predicate p4 = cb.like(
							standardJoin.get("name").as(String.class), "%"
									+ model.getStandard().getName() + "%");
					list.add(p4);
				}
				return cb.and(list.toArray(new Predicate[0]));
			}
		};
		
		
		
		//调用业务层，返回page
		Page<Courier> pageData = courierService.findPageData(specification,pageable);
		
		//将返回page对象，转化为datagrid需要格式
		Map<String,Object> result = new HashMap<String, Object>();
		result.put("total", pageData.getTotalElements());
		result.put("rows", pageData.getContent());
		
		//将map转化为json返回
		ActionContext.getContext().getValueStack().push(result);
		
		return SUCCESS;
	}
	
	//属性驱动
	private String ids;
	
	
	
	public void setIds(String ids) {
		this.ids = ids;
	}
	//作废快递员
	@Action(value="courier_delBatch",results={@Result(name="success",location="./pages/base/courier.html",type="redirect")})
	public String delBatch(){
		//按，来分割ids
		String[] idArray = ids.split(",");
		//调用业务层，批量作废
		courierService.delBatch(idArray);
		return SUCCESS;
	}
	
	//查询未关联定区的快递员
	@Action(value="courier_findnoassociation",
			results={@Result(name="success",type="json")})
	public String findnoassociation(){
		List<Courier> couriers = courierService.findNoAssociation();
		
		//将查询快递员列表压制值栈
		ActionContext.getContext().getValueStack().push(couriers);
		return SUCCESS;
	}
	
	
}
